﻿--HEADER Added columns [IsInErrorState] and [IsNoise] to [Analytics].[Investment] table

WHILE EXISTS(SELECT NULL FROM [Analytics].[Idea])
BEGIN
	DELETE TOP(500) FROM [Analytics].[Idea]
END

GO

ALTER TABLE [Analytics].[Investment]
ADD IsInErrorState BIT NOT NULL

GO

ALTER TABLE [Analytics].[Investment]
ADD IsNoise BIT NOT NULL
